package com.quanhenghe.Test;

public class Timetest {
	public static void main(String[] args) {
		  int timesp = 200,fid = 1850,jgid =30 ;
	      String updateSql="";
	      for(;fid<1930;fid+=jgid,timesp+=200) {
	    	  updateSql = String.format("UPDATE grab_source_conf " + 
	  	      		"SET grab_freq = %d " + 
	  	      		"WHERE station_id " + 
	  	      		"BETWEEN %d AND %d;", timesp,fid,fid+jgid);
	    	  System.out.println(updateSql);
	      }
	}
	
}
